CREATE TABLE `page_ad` (
  `id` int(11) NOT NULL auto_increment,
  `tag` varchar(200) NOT NULL default '',
  `code` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM 

CREATE TABLE `page_admin` (
  `id` int(3) NOT NULL auto_increment,
  `user` varchar(20) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

INSERT INTO `page_admin` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '2008-07-19 19:45:10');

CREATE TABLE `page_class` (
  `id` int(3) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `vip` mediumint(1) NOT NULL default '0',
  `idx` int(3) NOT NULL default '0',
  `xu` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

CREATE TABLE `page_du` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `urlname` varchar(200) NOT NULL default '',
  `vip` mediumint(1) NOT NULL default '0',
  `message` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM 

CREATE TABLE `page_index` (
  `id` mediumint(1) NOT NULL auto_increment,
  `webname` varchar(100) NOT NULL default '',
  `webkey` varchar(200) NOT NULL default '',
  `webdis` varchar(200) NOT NULL default '',
  `weburl` varchar(200) NOT NULL default '',
  `webtemp` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM 

CREATE TABLE `page_link` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `url` varchar(200) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM 

CREATE TABLE `page_page` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `user` varchar(20) NOT NULL default '',
  `web` varchar(20) NOT NULL default '',
  `class1` int(3) NOT NULL default '0',
  `class2` int(3) NOT NULL default '0',
  `class3` int(3) NOT NULL default '0',
  `imgurl` varchar(200) NOT NULL default '',
  `message` text NOT NULL,
  `vip` mediumint(1) NOT NULL default '0',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

CREATE TABLE `page_update` (
  `id` int(11) NOT NULL auto_increment,
  `filename` varchar(40) NOT NULL default '',
  `filetype` varchar(10) NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM 